File manager

File manager - Edit - /home/autoph/public_html/projects/Rating-AutoHub/public/css/sales_consultant.tar

Back
remove_sc.php��0000644��00000001236�15031151405�0007234 0��ustar�00��<?php include_once("../../cfg/db.php"); $gm_id = $db->escape(trim($_POST['gm_id'])); $sc_id = $db->escape(trim($_POST['sc_id'])); if(intval($db -> select("SELECT count(1) FROM `sales_group` WHERE `gm_id` = '$gm_id' AND `sc_id` = '$sc_id'")) > 0){ $query = "UPDATE sales_group SET `status` = 0 WHERE `gm_id` = '$gm_id' AND `sc_id` = '$sc_id'"; $db->sql_query($query); $change_assigned_status = "UPDATE `sales_consultant` SET `assigned` = 0 WHERE id = '$sc_id'"; $db->sql_query($change_assigned_status); $arr['status'] = 1; } else { $arr['status'] = 0; //error } echo json_encode($arr); ?> ��add_sales_consultant.php��0000644��00000002234�15031151405�0011442 0��ustar�00��<?php include_once("../../cfg/db.php"); $new_employee_id = $db->escape(trim(strtoupper($_POST['new_employee_id']))); $new_firstname = $db->escape(trim(strtoupper($_POST['new_first_name']))); $new_lastname = $db->escape(trim(strtoupper($_POST['new_last_name']))); //$current_user = $_SESSION['user']['id']; if($new_employee_id <> ''){ if(intval($db -> select("SELECT count(1) FROM sales_consultant WHERE status = 1 AND employee_id = '$new_employee_id'")) > 0){ $return_arr['status'] = 0; //duplicate employee id $return_arr['message'] = "Employee ID already existing"; echo json_encode($return_arr); }else{ insertSC($new_employee_id,$new_firstname,$new_lastname,$db); } } else { insertSC($new_employee_id,$new_firstname,$new_lastname,$db); } function insertSC($new_employee_id,$new_firstname,$new_lastname,$db){ $db->sql_query("INSERT INTO `sales_consultant` (`employee_id`, `first_name`, `last_name`,`status`) VALUES (NULLIF('$new_employee_id',''), '$new_firstname', '$new_lastname',1)"); $return_arr['status'] = 1; echo json_encode($return_arr); } ?>��load_sc_members.php��0000644��00000002565�15031151405�0010376 0��ustar�00��<?php include_once("../../cfg/db.php"); $type = $_POST['type']; if($type == 1){ $gsm_id = $db->escape(trim($_POST['gsm_id'])); $query = " SELECT sc.id, sc.first_name, sc.last_name FROM sales_group sg INNER JOIN sales_consultant sc ON sc.id = sg.sc_id WHERE gm_id = '$gsm_id' AND sg.status != 0"; //echo $query; return; $sc_members = $db -> return_result($query); foreach($sc_members AS $data){ echo "<option value='{$data['id']}'>" . $data['first_name']. " " . $data['last_name'] ."</option>"; } } else if($type == 2){ //search $search_item = $db->escape(trim($_POST['search_item'])); $gsm_id = $db->escape(trim($_POST['gm_id'])); $query = " SELECT sc.id, sc.first_name, sc.last_name FROM sales_group sg INNER JOIN sales_consultant sc ON sc.id = sg.sc_id WHERE gm_id = '$gsm_id' AND sg.status != 0 AND ((sc.first_name LIKE '%$search_item%') OR (sc.last_name LIKE '%$search_item%') OR (sc.employee_id LIKE '%$search_item%'))"; //echo $query; return; $sc_members = $db -> return_result($query); foreach($sc_members AS $data){ echo "<option value='{$data['id']}'>" . $data['first_name']. " " . $data['last_name'] ."</option>"; } } ?> ��update_sales_consultant.php��0000644��00000002371�15031151405�0012176 0��ustar�00��<?php include_once("../../cfg/db.php"); $id = $db->escape(trim($_POST['sc_id'])); $employee_id = $db->escape(trim($_POST['employee_id'])); $first_name = $db->escape(trim(strtoupper($_POST['first_name']))); $last_name = $db->escape(trim(strtoupper($_POST['last_name']))); $position = $db->escape(trim($_POST['position'])); $mobile_1 = $db->escape(trim(strtoupper($_POST['mobile_1']))); $mobile_2 = $db->escape(trim(strtoupper($_POST['mobile_2']))); $email_1 = $db->escape(trim(strtoupper($_POST['email_1']))); $email_2 = $db->escape(trim(strtoupper($_POST['email_2']))); if(intval($db -> select("SELECT count(1) FROM sales_consultant WHERE `employee_id` != '' AND `employee_id` = '$employee_id' AND id != '$id'")) > 0){ $arr['status'] = 0; //duplicate employee id } else { $update_query = "UPDATE `sales_consultant` SET `employee_id`='$employee_id', `first_name`='$first_name', `last_name` = '$last_name', `type` = '$position', `mobile_1`='$mobile_1', `mobile_2`='$mobile_2', `email_1`='$email_1', `email_2`='$email_2' WHERE `id` = '$id'"; //echo $update_query; $db->sql_query($update_query); $arr['status'] = 1; //success update } echo json_encode($arr); ?> ��remove_sales_consultant.php��0000644��00000000520�15031151405�0012203 0��ustar�00��<?php include_once("../../cfg/db.php"); $id = $db->escape(trim($_POST['sc_id'])); $update_query = "UPDATE `sales_consultant` SET `status`= '0' WHERE `id` = '$id'"; //echo $update_query; $db->sql_query($update_query); $arr['status'] = 1; //success update echo json_encode($arr); ?> ��reload_sales_consultant.php��0000644��00000007353�15031151405�0012167 0��ustar�00��<?php include_once("../../cfg/db.php"); $type = $_POST['type']; if($type == 1){ $query = "SELECT `id`, `employee_id`, `first_name`, `last_name` FROM `sales_consultant` WHERE id != 0 AND status = 1"; $sales_consultant = $db -> return_result($query); //echo $query; return; foreach($sales_consultant as $data){ echo "<option value='{$data['id']}'>" . $data['first_name']. " " . $data['last_name'] ."</option>"; } } else if($type == 2){ //if(isset($_POST['sc_id'])){ $sc_id = $_POST['sc_id']; $query = " SELECT id, first_name, last_name, employee_id, DATE_FORMAT(date_added, '%M %d, %Y / %h:%i:%s %p') AS date_added, type, mobile_1, mobile_2, email_1, email_2 FROM `sales_consultant` /INNER JOIN employee e ON e.id = cac.added_by/ WHERE id != 0 AND id = '$sc_id' AND status = 1"; //echo $query; return; $sales_consultant_details = $db -> return_result($query); foreach($sales_consultant_details AS $data){ $arr['employee_id'] = $data['employee_id']; $arr['first_name'] = $data['first_name']; $arr['last_name'] = $data['last_name']; $arr['date_added'] = $data['date_added']; $arr['type'] = $data['type']; $arr['mobile_1'] = $data['mobile_1']; $arr['mobile_2'] = $data['mobile_2']; $arr['email_1'] = $data['email_1']; $arr['email_2'] = $data['email_2']; } echo json_encode($arr); //} } else if($type == 3){ $search_item = $db->escape(trim($_POST['search_item'])); $search_query = "SELECT id, employee_id, first_name, last_name FROM sales_consultant WHERE CONCAT(IFNULL(employee_id,''),' ',first_name,' ',last_name,' ',first_name) LIKE '%$search_item%' AND status = 1 AND id != 0 "; $result = $db->sql_query($search_query); //echo $search_query; return; while($row = $result->fetch_assoc()) { echo '<option value="'.$row['id'].'">'. $row['first_name'] . " " . $row['last_name'].'</option>'; } } else if($type == 4){ $query = " SELECT id, employee_id, first_name, last_name FROM sales_consultant WHERE id != 0 AND status = 1 AND type = 0 AND assigned = 0/GROUP BY sc.id/ LIMIT 10"; //echo $query; return; $scs = $db -> return_result($query); foreach($scs as $data){ echo "<option value='{$data['id']}'>" . $data['first_name'] . " " . $data['last_name'] ."</option>"; } } else if($type == 5){ //refresh add sc list $query = " SELECT id, employee_id, first_name, last_name FROM sales_consultant WHERE id != 0 AND status = 1 /GROUP BY sc.id/"; //echo $query; return; $scs = $db -> return_result($query); foreach($scs as $data){ echo "<option value='{$data['id']}'>" . $data['first_name'] . " " . $data['last_name'] ."</option>"; } } else if($type == 6){ //reload designate GM list $query = " SELECT id, employee_id, first_name, last_name FROM sales_consultant WHERE id != 0 AND status = 1 AND type = 1/GROUP BY sc.id/"; //echo $query; return; $gms = $db -> return_result($query); foreach($gms as $data){ echo "<option value='{$data['id']}'>" . $data['first_name'] . " " . $data['last_name'] ."</option>"; } } else if($type == 7){ $search_item = $db -> escape(trim($_POST['search_item'])); $query = " SELECT id, employee_id, first_name, last_name FROM sales_consultant WHERE id != 0 AND status = 1 AND type = 0 AND assigned = 0 AND CONCAT(IFNULL(employee_id,''),' ',first_name,' ',last_name,' ',first_name) LIKE '%$search_item%' /GROUP BY sc.id/ LIMIT 10"; //echo $query; return; $scs = $db -> return_result($query); foreach($scs as $data){ echo "<option value='{$data['id']}'>" . $data['first_name'] . " " . $data['last_name'] ."</option>"; } } ?>��designate_sc.php��0000644��00000001656�15031151405�0007710 0��ustar�00��<?php include_once("../../cfg/db.php"); $gm_id = $db->escape(trim($_POST['gm_id'])); $sc_id = $db->escape(trim($_POST['sc_id'])); if(intval($db -> select("SELECT count(1) FROM `sales_group` WHERE `gm_id` = '$gm_id' AND `sc_id` = '$sc_id'")) > 0){ $query = "UPDATE sales_group SET `status` = 1 WHERE `gm_id` = '$gm_id' AND `sc_id` = '$sc_id'"; $db->sql_query($query); $change_assigned_status = "UPDATE `sales_consultant` SET `assigned` = 1 WHERE id = '$sc_id'"; $db->sql_query($change_assigned_status); $arr['status'] = 1; } else { $query = "INSERT INTO `sales_group` (`gm_id`, `sc_id`) VALUES('$gm_id', '$sc_id')"; $db->sql_query($query); $change_assigned_status = "UPDATE `sales_consultant` SET `assigned` = 1 WHERE id = '$sc_id'"; $db->sql_query($change_assigned_status); $arr['status'] = 1; // } echo json_encode($arr); ?> ��

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0 | proxy | phpinfo | Settings